.class public Lcom/netease/newsreader/db/NewsSQLiteOpenHelper;
.super Landroid/database/sqlite/SQLiteOpenHelper;
.source "NewsSQLiteOpenHelper.java"


# static fields
.field public static final ARTICLE_READ_AUTO_ID:Ljava/lang/String; = "article_read_auto_id"

.field public static final ARTICLE_READ_COL_ID:Ljava/lang/String; = "article_read_col_id"

.field public static final ARTICLE_READ_DOC_ID:Ljava/lang/String; = "article_read_doc_id"

.field public static final ARTICLE_READ_LIST_TABLE:Ljava/lang/String; = "article_read_status_list"

.field public static final ARTICLE_READ_STATUS:Ljava/lang/String; = "article_read_is_read"

.field public static final CID:Ljava/lang/String; = "cid"

.field public static final CITY_AUTO_ID:Ljava/lang/String; = "city_auto_id"

.field public static final CITY_NAME:Ljava/lang/String; = "city_name"

.field public static final CITY_PINYIN:Ljava/lang/String; = "city_pinyin"

.field public static final CITY_PROVINCE:Ljava/lang/String; = "city_province"

.field public static final CITY_SELECT_COUNT:Ljava/lang/String; = "city_select_count"

.field public static final CITY_TABLE:Ljava/lang/String; = "city_list"

.field public static final COLLECT_AUTOID:Ljava/lang/String; = "auto_id"

.field public static final COLLECT_CREATE_AT:Ljava/lang/String; = "create_at"

.field public static final COLLECT_IMAGE_LOCAL:Ljava/lang/String; = "image_loacl"

.field public static final COLLECT_ISCHECKED:Ljava/lang/String; = "ischecked"

.field public static final COLLECT_OBJID:Ljava/lang/String; = "collect_id"

.field public static final COLLECT_PATH:Ljava/lang/String; = "collect_path"

.field public static final COLLECT_TABLE:Ljava/lang/String; = "collect_table"

.field public static final COLLECT_TITLE:Ljava/lang/String; = "collect_title"

.field public static final COLLECT_TYPE:Ljava/lang/String; = "collect_type"

.field public static final COMMENTS_AUTHOR:Ljava/lang/String; = "comments_author"

.field public static final COMMENTS_AUTO_ID:Ljava/lang/String; = "comments_auto_id"

.field public static final COMMENTS_COL_ID:Ljava/lang/String; = "comments_col_id"

.field public static final COMMENTS_DOC_ID:Ljava/lang/String; = "comments_doc_id"

.field public static final COMMENTS_FLOOR:Ljava/lang/String; = "comments_floor"

.field public static final COMMENTS_IS_READ:Ljava/lang/String; = "comments_is_read"

.field public static final COMMENTS_LIST_TABLE:Ljava/lang/String; = "comments_list"

.field public static final COMMENTS_POSTID:Ljava/lang/String; = "comments_postid"

.field public static final COMMENTS_PTIME:Ljava/lang/String; = "comments_ptime"

.field public static final COMMENTS_REPLY_BOARD:Ljava/lang/String; = "comments_reply_board"

.field public static final COMMENTS_REPLY_COUNT:Ljava/lang/String; = "comments_reply_count"

.field public static final COMMENTS_TIE:Ljava/lang/String; = "comments_tie"

.field public static final COMMENTS_TITLE:Ljava/lang/String; = "comments_title"

.field private static final DATABASE_NAME:Ljava/lang/String; = "netease_news.db"

.field private static final DATABASE_VERSION:I = 0x49

.field public static final DEFAULT_SORT_ORDER:Ljava/lang/String; = "id DESC"

.field public static final MORE_COLUMN_TABLE:Ljava/lang/String; = "more_columns"

.field public static final MYID:Ljava/lang/String; = "myid"

.field public static final NEWS_AUTO_ID:Ljava/lang/String; = "news_auto_id"

.field public static final NEWS_COL_ID:Ljava/lang/String; = "news_col_id"

.field public static final NEWS_DIGEST:Ljava/lang/String; = "news_digest"

.field public static final NEWS_DOC_ID:Ljava/lang/String; = "news_doc_id"

.field public static final NEWS_EXTENDS_JSON:Ljava/lang/String; = "news_extends_json"

.field public static final NEWS_IMG_SRC:Ljava/lang/String; = "news_img_src"

.field public static final NEWS_IS_FIRST:Ljava/lang/String; = "news_is_first"

.field public static final NEWS_IS_HASIMG:Ljava/lang/String; = "news_is_hasimg"

.field public static final NEWS_IS_READ:Ljava/lang/String; = "news_is_read"

.field public static final NEWS_LIST_TABLE:Ljava/lang/String; = "news_list"

.field public static final NEWS_PTIME:Ljava/lang/String; = "news_ptime"

.field public static final NEWS_REPLY_COUNT:Ljava/lang/String; = "news_reply_count"

.field public static final NEWS_SPECIAL_ID:Ljava/lang/String; = "news_special_id"

.field public static final NEWS_SPECIAL_INDEX:Ljava/lang/String; = "news_index"

.field public static final NEWS_SPECIAL_TNAME:Ljava/lang/String; = "news_special_tname"

.field public static final NEWS_SUBTITLE:Ljava/lang/String; = "news_subtitle"

.field public static final NEWS_TITLE:Ljava/lang/String; = "news_title"

.field public static final NEWS_URL:Ljava/lang/String; = "news_url"

.field public static final OAUTH_AUTO_ID:Ljava/lang/String; = "oauth_auto_id"

.field public static final OAUTH_NAME:Ljava/lang/String; = "oauth_name"

.field public static final OAUTH_TABLE:Ljava/lang/String; = "oauth_list"

.field public static final OAUTH_TOKEN:Ljava/lang/String; = "oauth_token"

.field public static final OAUTH_TOKEN_SECRET:Ljava/lang/String; = "oauth_token_secret"

.field public static final OAUTH_TYPE:Ljava/lang/String; = "oauth_type"

.field public static final PHOTO_AUTO_ID:Ljava/lang/String; = "photo_auto_id"

.field public static final PHOTO_CLIENTCOVER:Ljava/lang/String; = "photo_clientcover"

.field public static final PHOTO_DATE:Ljava/lang/String; = "photo_date"

.field public static final PHOTO_IMGSUM:Ljava/lang/String; = "photo_imgsum"

.field public static final PHOTO_LIST_TABLE:Ljava/lang/String; = "photo_list"

.field public static final PHOTO_SETID:Ljava/lang/String; = "photo_setid"

.field public static final PHOTO_SETNAME:Ljava/lang/String; = "photo_setname"

.field public static final PIC_AUTO_ID:Ljava/lang/String; = "pic_auto_id"

.field public static final PIC_JSON:Ljava/lang/String; = "pic_json"

.field public static final PIC_SETID:Ljava/lang/String; = "pic_setid"

.field public static final PIC_TABLE:Ljava/lang/String; = "pic"

.field private static final TAG:Ljava/lang/String; = "newsDB"

.field public static final TID:Ljava/lang/String; = "tid"

.field public static final TNAME:Ljava/lang/String; = "tname"

.field public static final TOP_COLUMN_TABLE:Ljava/lang/String; = "top_columns"

.field public static final VOTE_AUTO_ID:Ljava/lang/String; = "auto_id"

.field public static final VOTE_ID:Ljava/lang/String; = "vote_id"

.field public static final VOTE_TABLE:Ljava/lang/String; = "vote_table"


# direct methods
.method public constructor <init>(Landroid/content/Context;)V
    .locals 3
    .parameter "context"

    .prologue
    .line 120
    const-string v0, "netease_news.db"

    const/4 v1, 0x0

    const/16 v2, 0x49

    invoke-direct {p0, p1, v0, v1, v2}, Landroid/database/sqlite/SQLiteOpenHelper;-><init>(Landroid/content/Context;Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)V

    .line 122
    return-void
.end method


# virtual methods
.method public onCreate(Landroid/database/sqlite/SQLiteDatabase;)V
    .locals 1
    .parameter "db"

    .prologue
    .line 127
    const-string v0, "CREATE TABLE top_columns (myid INTEGER PRIMARY KEY AUTOINCREMENT,tname NTEXT,tid NTEXT,cid NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 133
    const-string v0, "CREATE TABLE more_columns (myid INTEGER PRIMARY KEY AUTOINCREMENT,tname NTEXT,tid NTEXT,cid NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 141
    const-string v0, "CREATE TABLE vote_table (auto_id INTEGER PRIMARY KEY AUTOINCREMENT,vote_id NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 147
    const-string v0, "CREATE TABLE collect_table (auto_id INTEGER PRIMARY KEY AUTOINCREMENT,collect_path NTEXT,collect_id NTEXT,collect_title NTEXT,collect_type NTEXT,create_at NTEXT,ischecked NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 159
    const-string v0, "CREATE TABLE news_list (news_auto_id INTEGER PRIMARY KEY AUTOINCREMENT,news_col_id NTEXT,news_doc_id NTEXT,news_img_src NTEXT,news_digest NTEXT,news_reply_count NTEXT,news_url NTEXT,news_title NTEXT,news_ptime NTEXT,news_subtitle NTEXT,news_is_first NTEXT,news_is_read NTEXT,news_is_hasimg NTEXT,news_special_id NTEXT,news_index NTEXT,news_special_tname NTEXT,news_extends_json NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 180
    const-string v0, "CREATE TABLE comments_list (comments_auto_id INTEGER PRIMARY KEY AUTOINCREMENT,comments_col_id NTEXT,comments_doc_id NTEXT,comments_reply_count NTEXT,comments_title NTEXT,comments_tie NTEXT,comments_author NTEXT,comments_reply_board NTEXT,comments_postid NTEXT,comments_floor NTEXT,comments_is_read NTEXT,comments_ptime NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 196
    const-string v0, "CREATE TABLE photo_list (photo_auto_id INTEGER PRIMARY KEY AUTOINCREMENT,photo_setid INTEGER,photo_clientcover NTEXT,photo_setname NTEXT,photo_imgsum NTEXT,photo_date NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 206
    const-string v0, "CREATE TABLE pic (pic_auto_id INTEGER PRIMARY KEY AUTOINCREMENT,pic_setid NTEXT,pic_json NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 213
    const-string v0, "CREATE TABLE article_read_status_list (article_read_auto_id INTEGER PRIMARY KEY AUTOINCREMENT,article_read_col_id NTEXT,article_read_doc_id NTEXT,article_read_is_read NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 221
    const-string v0, "CREATE TABLE oauth_list (oauth_auto_id INTEGER PRIMARY KEY AUTOINCREMENT,oauth_type NTEXT,oauth_token NTEXT,oauth_token_secret NTEXT,oauth_name NTEXT);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 230
    const-string v0, "CREATE TABLE city_list (city_auto_id INTEGER PRIMARY KEY AUTOINCREMENT,city_name NTEXT,city_province NTEXT,city_pinyin NTEXT,city_select_count INTEGER);"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 237
    return-void
.end method

.method public onUpgrade(Landroid/database/sqlite/SQLiteDatabase;II)V
    .locals 3
    .parameter "db"
    .parameter "oldVersion"
    .parameter "newVersion"

    .prologue
    .line 242
    const-string v0, "newsDB"

    new-instance v1, Ljava/lang/StringBuilder;

    const-string v2, "Upgrading database from version "

    invoke-direct {v1, v2}, Ljava/lang/StringBuilder;-><init>(Ljava/lang/String;)V

    invoke-virtual {v1, p2}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;

    move-result-object v1

    const-string v2, " to "

    invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v1

    .line 243
    invoke-virtual {v1, p3}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;

    move-result-object v1

    const-string v2, ", which will destroy all old data"

    invoke-virtual {v1, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    move-result-object v1

    invoke-virtual {v1}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v1

    .line 242
    invoke-static {v0, v1}, Landroid/util/Log;->w(Ljava/lang/String;Ljava/lang/String;)I

    .line 244
    const-string v0, "DROP TABLE IF EXISTS top_columns"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 245
    const-string v0, "DROP TABLE IF EXISTS more_columns"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 246
    const-string v0, "DROP TABLE IF EXISTS vote_table"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 247
    const-string v0, "DROP TABLE IF EXISTS collect_table"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 248
    const-string v0, "DROP TABLE IF EXISTS news_list"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 249
    const-string v0, "DROP TABLE IF EXISTS comments_list"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 250
    const-string v0, "DROP TABLE IF EXISTS photo_list"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 251
    const-string v0, "DROP TABLE IF EXISTS pic"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 252
    const-string v0, "DROP TABLE IF EXISTS article_read_status_list"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 253
    const-string v0, "DROP TABLE IF EXISTS oauth_list"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 254
    const-string v0, "DROP TABLE IF EXISTS city_list"

    invoke-virtual {p1, v0}, Landroid/database/sqlite/SQLiteDatabase;->execSQL(Ljava/lang/String;)V

    .line 255
    invoke-virtual {p0, p1}, Lcom/netease/newsreader/db/NewsSQLiteOpenHelper;->onCreate(Landroid/database/sqlite/SQLiteDatabase;)V

    .line 256
    return-void
.end method

.method public updateNewsDB(Landroid/database/sqlite/SQLiteDatabase;)V
    .locals 0
    .parameter "db"

    .prologue
    .line 266
    return-void
.end method
